SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 862008 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 862008 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164405,125218,488860,421692,261259,530297,973891,198227,900017,917427,1001171,967850,102878,435479,25843,193590,192711,587618,182043,251634,392344,194377,590154,154937,1045992,682312,721421,445625,920332,306272,646431,299852,470348,231081,411292,152074,233454,552887,262529,487503,781715,352650,272505,318238,316786,635986,580971,820060,860565,561681,625549,448588,30000,140140,400405,78825,644797,940476,777368,605685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 862008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 862008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]