SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 369686 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 369686 [ RunTime:0.002771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454841,839918,272150,59761,252907,805773,728362,982316,703185,885029,409714,833699,410618,263289,147842,557732,803098,656915,638076,877116,895305,387175,929939,557764,123790,889198,269093,972634,44726,962659,447865,679836,344621,1029244,133173,441073,780025,999854,506690,836961,507291,10765,88401,28302,186212,881157,263455,151070,1024585,596063,282945,765635,737914,713703,129057,870418,1006544,160568,615904,86571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 369686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 369686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002266s ]