SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455262 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455262 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788888,649406,541208,632587,430569,4857,764745,701764,186575,454915,519783,399306,758161,785785,675813,372257,946813,333150,587176,504777,66961,792548,240288,270983,962731,283026,899674,1001850,1043458,592101,602899,281756,1031652,145869,351058,121767,204802,624078,219839,51789,639926,596047,91321,531136,190127,625810,1006823,961339,1014204,530440,115874,1005602,882419,416772,1004005,344919,991960,946771,489297,118694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455262 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455262 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]