SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002707s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41802 LIMIT 1 [ RunTime:0.000992s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41802 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579666,1044211,1019665,78276,187474,779194,498599,388482,33484,657617,70518,203590,1034807,998620,54797,1001840,696875,238572,982882,28874,999644,619925,467351,1022477,112372,1001718,909724,152080,393489,677921,137714,945728,233208,321972,182926,286529,299050,389437,637374,405577,91174,494651,67662,584985,294614,591749,974681,259972,91344,784591,76067,456306,892512,14984,470983,835252,716828,752,618846,699970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001017s ]