SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194092 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194092 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503348,640374,826728,162400,351925,829177,866585,599414,998591,186071,806871,987585,1279,160949,208583,551746,680743,863000,929282,1032979,679087,576974,978921,945785,299393,56698,566325,1034866,123351,494480,315273,694775,978239,536681,524258,996779,883482,533457,680537,73267,255636,1047122,442215,446326,305167,1033561,768113,823614,723186,434693,757179,458667,607077,178169,633291,986941,401023,934375,170839,406077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]