SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400601 LIMIT 1 [ RunTime:0.000941s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400601 [ RunTime:0.006475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866481,546538,187933,500413,655518,918212,201598,896816,742186,236931,807656,893439,719654,1015633,1027875,817785,858362,876745,239932,333539,935167,317878,694964,724389,685633,660442,394191,607157,352960,456867,747874,804562,172474,491894,134292,50516,27028,842949,61472,901030,343778,270331,470563,895807,984796,593421,187505,100557,408983,639252,895468,288647,675397,290982,562294,573365,561229,189431,1028009,520529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]