SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517728 LIMIT 1 [ RunTime:0.001042s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517728 [ RunTime:0.003241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794470,501115,338893,588445,514363,1033075,537681,717561,705972,634489,290226,781105,477850,401031,545022,942866,72674,186710,411022,170917,265785,228572,334160,15628,564191,28832,142852,283226,192503,536788,17691,577217,197420,983969,674230,987008,391957,440738,494279,408026,892239,292635,658202,451211,276220,1028582,452698,478961,569707,716803,284920,826667,191000,675737,916120,9796,142382,130272,855564,86293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002521s ]