SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317201 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317201 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83717,347213,422726,979948,675982,167398,2760,111243,383249,667585,155744,408053,412187,666193,145710,38100,325955,1042097,761011,413121,61898,861591,751143,193903,277988,357781,396835,236947,618237,418834,1045528,841732,354793,1001180,323151,968493,389377,607530,119492,370730,101212,640822,302871,234060,203268,717725,216502,96778,438857,783643,295224,677944,532543,669995,635838,982547,898434,706673,952232,972694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003497s ]