SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534965 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534965 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403375,104291,669362,294351,858016,583991,944281,391023,719255,1013179,850966,191717,153494,47616,664448,31163,194157,56551,206876,444086,560337,880651,1002880,803892,1018466,58938,147332,256296,793456,625415,265667,817142,260656,369796,149098,689143,334982,957682,114202,108930,973211,612762,363718,478313,656918,776637,358281,439228,637213,845376,626649,849588,501452,26532,467838,209278,326599,869705,473508,287216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534965 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534965 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]