SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501848 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501848 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274430,130654,242329,850946,732,84215,918600,442514,904131,790957,223259,776568,257497,68087,1036368,113025,32108,462262,782389,62553,696629,1040180,265986,941189,457003,459712,797166,40574,1033266,892967,764415,948047,948598,1034098,331510,784342,209915,1018296,172532,415127,152613,313909,246589,413340,860207,407813,759229,726349,92685,680937,373464,228951,751472,294055,223692,711130,20410,42603,678906,1023178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]