SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463327 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463327 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374627,312870,258275,654913,869407,138171,939073,756488,134012,957635,302058,208907,991131,48953,338918,5793,734983,207577,304428,789721,601544,410538,881415,40020,513841,556775,499326,835926,926772,871199,490694,768398,803717,111635,137576,242279,557449,842279,586773,808328,65047,706643,674944,269038,52803,237502,848463,328645,412652,916353,426964,772877,767611,914800,184162,452844,377868,163452,171265,618136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]