SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023085 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023085 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815261,893617,1007719,496769,490379,894430,702192,320438,74630,621658,807864,119600,1028730,838643,759241,769581,1013262,489922,712648,1019241,443245,355857,889376,1001049,90114,250885,423882,592430,865917,5154,245747,524454,368054,590435,393398,855584,845028,500919,546125,503111,370638,254068,28519,534210,124394,554243,134820,389144,967415,719275,583710,689176,479950,803186,737720,356400,49691,125703,363371,982345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]