SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450007 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450007 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570507,756193,518620,754935,813093,732223,100853,260560,386718,107480,377010,223778,928893,560576,931773,966784,288788,99398,34888,159254,689855,896928,601900,284689,72132,472945,472437,172902,810133,517471,433557,481188,477124,359365,897331,610297,444021,706992,634168,282947,575413,467460,793614,88858,170738,1044701,980472,605699,926510,1015660,223353,692688,54500,680101,484984,877930,635045,168959,705583,29639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]