SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 652343 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 652343 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611448,417856,611411,821821,909402,797870,632966,722287,276715,565248,261428,810608,255383,822962,910895,881692,974684,244754,364333,836388,723643,389970,456908,770880,705737,347090,453079,208912,816074,484768,135320,752921,857249,209612,391030,82657,230205,767425,878759,694367,251334,484379,243015,919334,226759,489709,1014608,318746,835926,442899,1623,289012,1037928,612822,500269,137336,60265,69292,561204,387027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 652343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 652343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]