SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413629 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413629 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220589,10349,626027,821552,82066,334837,928449,552808,230731,687321,203246,116278,1026705,453438,565093,737234,513593,27181,938692,174953,982196,764330,254388,694440,952236,422534,602376,405857,31611,179408,212975,675079,473868,168378,385001,1047385,881108,861423,264780,902502,517890,550786,784153,747803,623965,538893,442226,490725,71454,524948,318714,501813,207092,83315,431594,488472,422915,475056,163024,518041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]