SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546311 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546311 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010805,944375,892323,65096,137917,591463,981717,424879,262302,700118,604652,526535,875635,503603,3306,596538,902,194858,28561,388269,1026668,121634,816589,731010,43735,358721,374788,879622,678009,506317,897444,773465,947589,177247,921894,137233,884819,740353,27843,658889,163647,247488,297433,876273,841467,466445,150642,138520,452487,414567,56890,1041587,751808,2859,416728,279184,884120,248840,81808,865321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]