SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017687 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017687 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525889,259023,161432,250355,665628,144957,722065,359300,247503,480511,801449,803508,475039,936352,14737,331277,944865,162260,923443,26134,515172,168466,347300,655836,816804,500239,237500,330689,294945,390842,1043984,558657,10492,946840,640812,792103,507948,887111,946314,614746,954453,714964,391680,885201,990570,415092,628977,1019769,860159,218403,148587,87324,70692,262956,630247,992158,1007230,785783,31584,192228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]