SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036798 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036798 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88112,169060,118602,953562,944004,200468,852985,849788,747909,238143,1022805,246126,319550,58100,904123,854701,576214,626114,877753,57031,845986,473537,107330,608431,38191,279809,362035,344117,104719,930621,661443,824833,642899,812973,241733,34508,730852,417419,990625,1001222,83356,616247,1037168,569810,678548,750331,895878,270456,900087,587983,156600,66715,56448,380418,100855,602825,705236,860303,549196,792493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]