SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30199 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30199 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22923,252359,691825,639090,202825,801793,186951,161393,504270,518349,1042214,874939,473251,471987,581833,824678,784618,1046517,617191,341414,970782,226052,60150,426170,371705,1009964,824439,29909,198592,46591,287662,530386,322811,739377,56044,449736,1025907,128855,106110,765759,523958,1044404,138184,240091,949437,387082,943423,1027805,498600,821000,32887,202763,506081,855599,907099,525448,959783,812512,141025,1007341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]