SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001759s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542840 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542840 [ RunTime:0.003374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226289,851606,349316,100357,1008796,436280,201453,827077,398865,339535,77660,244268,8101,653412,1048109,315516,187024,961617,816935,303889,677509,658306,931805,35427,823915,934870,381491,643408,486374,150260,148125,777700,585277,308221,149541,314257,978186,987171,578655,620999,486748,73864,627668,181731,1009471,1038767,400070,674249,285101,601073,329946,782211,10789,536044,629991,1002864,898241,920051,492685,939874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]