SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449704 LIMIT 1 [ RunTime:0.003473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449704 [ RunTime:0.002370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032564,264350,163363,150523,945090,50108,739672,611358,716768,503387,355725,871105,656601,918673,297900,52533,80815,392465,126057,1011330,495120,67727,962574,684274,256009,94405,13044,685956,44669,991853,431209,882657,973661,509223,645930,556268,913441,997774,531946,666870,153474,783572,7488,153366,879307,269870,287751,155106,755439,475275,779204,476967,981348,526,1047814,223572,936289,492355,263298,685269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]