SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511529 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511529 [ RunTime:0.003035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113018,6710,34982,319534,471069,107902,579006,95441,522735,966504,681371,931534,1014844,605635,649558,710118,506183,626010,546006,695828,258547,521117,504926,67788,14872,525482,848314,1039857,83505,310692,667866,1045413,234729,109328,668401,261127,256720,646991,949889,819900,129365,633300,234798,917805,189036,194355,369488,365531,504923,607936,184119,203210,792973,550891,765312,728813,781444,128245,370781,360059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]