SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518778 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518778 [ RunTime:0.002341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534275,618458,235638,513974,928855,151341,310258,655731,417262,17152,733295,98165,130381,89635,995329,144639,715287,830074,1019494,1040783,854221,643947,798828,344486,272703,571109,887744,301981,1031854,350274,930381,1004173,192151,863266,308690,51460,192152,535688,954302,896417,546329,40279,3183,852239,348457,383691,385295,362576,628206,204784,961064,887359,28587,531454,838034,203748,585193,144557,387177,813477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001776s ]