SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341311 LIMIT 1 [ RunTime:0.003527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341311 [ RunTime:0.005711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217497,730161,488209,185129,755664,788587,616364,608217,348944,583331,275314,753162,987503,232967,903884,605353,701654,1000952,260349,857081,269253,410079,375345,167171,168657,381566,29807,228497,1001973,711551,650976,952085,915751,871153,450651,801091,670629,130048,354876,599507,8206,564981,230660,804831,426102,374369,322255,597693,421325,809312,579654,621130,833747,750814,873985,748208,760478,1047281,335409,43122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001823s ]