SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 629966 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 629966 [ RunTime:0.002928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3584,1036798,416010,964581,791359,46845,67538,86887,381569,1047894,421054,881032,10584,567299,583997,740761,1002795,160534,885380,418119,234497,511936,635046,1026101,577467,55145,21171,298131,470924,340544,200833,411757,549189,833444,1008212,218097,548898,383473,624164,695506,870228,820605,335936,949505,1019876,749231,858816,623878,815643,449582,490245,404555,996123,1047148,862693,717679,730803,717842,87603,979338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 629966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 629966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]