SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576845 LIMIT 1 [ RunTime:0.001788s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576845 [ RunTime:0.004008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217429,833159,713228,171671,572210,990393,1047680,478511,1982,628451,66412,525460,1042591,351673,761993,941950,609136,384927,923267,552932,516430,553074,563511,145884,112646,104442,335936,47609,528026,398974,192067,211167,617501,767511,885132,9260,896153,380413,84898,579134,530247,929822,808011,893751,587421,669565,808677,656600,31419,498291,146458,946484,492176,229337,363710,743489,588044,367371,307488,3746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001216s ]