SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004581 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004581 [ RunTime:0.002175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72283,136776,10342,377453,1017273,430527,343415,800815,848546,424578,279100,482814,771439,210276,553761,523479,69210,902139,626856,270446,254386,7612,951658,759504,329375,272211,195900,492836,770934,18652,569968,517219,544884,992691,171814,233385,288334,3851,7751,257033,841302,660609,188819,334662,829460,653964,463587,491956,573069,1808,380108,675714,138680,195992,477177,947589,100320,744007,479330,460880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]