SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405038 LIMIT 1 [ RunTime:0.000887s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405038 [ RunTime:0.004197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566049,993542,68494,471792,165907,850575,354305,118478,409219,60416,751074,978942,482069,242642,192712,815502,546233,127154,599048,424717,668687,172761,989433,620332,219512,133900,1025855,114551,654219,35163,249576,1012975,646105,853785,120968,306099,14917,241401,268236,896004,728283,351288,122840,695489,772681,893510,721667,664198,184612,389222,610432,398427,283253,625078,1005305,115822,313482,340805,959203,6237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003990s ]