SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046863 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046863 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489968,683922,509619,1036477,93903,451833,136096,998594,600516,69157,574121,32546,743418,545815,524159,657411,180577,457230,845259,775426,585697,509496,466575,617273,842126,967886,662168,720168,859049,717076,336265,520808,694603,927397,629033,428100,105080,105361,1043935,532212,405930,654439,823507,1027588,404087,239809,93005,587497,323997,299042,164484,449578,922290,598441,629532,781244,593100,314392,108196,348524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]