SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037148 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037148 [ RunTime:0.003248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867634,365722,986899,675046,128041,155505,39952,51602,813708,398981,497533,220539,654879,991019,628746,334102,26366,273543,192186,143265,147290,976724,80187,291573,864900,280129,535777,80733,586430,983706,257871,910913,188839,474780,842136,1028101,137461,92839,469463,732723,608935,453656,710807,924546,25328,644247,384839,856298,763146,228750,785696,85863,941755,338829,613181,905595,720134,745729,933212,265493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]