SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 138160 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 138160 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333527,852664,804622,175621,961511,441154,983508,870165,760320,88754,615056,121804,830689,378712,363960,8886,387226,862943,697524,1030054,232084,445843,29491,567866,152160,196578,560519,1017963,145166,785314,382041,633215,717642,36072,430683,455286,531677,413127,206069,356332,424555,927744,942913,128047,215832,182074,873453,49278,942698,500224,419659,138397,64828,997687,515564,473497,554626,928019,57244,866368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 138160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 138160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]