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` = 36411 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36411 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597131,44005,266980,753121,680483,887599,365716,648211,436254,116668,781601,717414,981160,413246,397485,39572,173768,362212,721484,777586,190612,661693,161428,1041801,163462,33706,214824,557635,769107,54368,654460,523910,954429,361783,14923,649952,288852,990392,455572,290616,80970,844976,81384,579845,244886,170090,926961,987200,790399,821279,443192,4490,454137,804170,675261,148618,940240,106171,660377,452626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]