SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391691 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391691 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465152,749209,785775,357139,839493,82330,148680,410525,690061,144347,672691,370941,621566,206824,34984,789838,585556,904426,24572,270973,791009,621263,916315,33375,613010,586508,141122,702030,515953,147801,395529,902714,360709,304659,1033496,1068,1037488,445684,454588,897833,261269,148056,352383,1030822,751825,889314,306633,713248,869362,29736,499253,108123,1040518,622632,590767,162475,832395,112389,1035307,328002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]