SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 373991 LIMIT 1 [ RunTime:0.002423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 373991 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205074,839659,270180,146090,56538,461968,972834,262398,71500,943068,1043443,95614,691567,958095,952620,833608,47674,104884,429796,951311,504914,643015,736361,285699,723273,205274,169482,938788,486089,1025247,533365,193067,836263,441730,316262,740360,554965,437257,989683,235837,453206,689366,722510,33617,800441,193451,747602,920434,923764,556129,349223,1012416,262326,666680,568415,1024210,136735,145506,609095,525004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 373991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 373991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]