SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414638 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414638 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215923,5583,878872,547076,207094,672491,1003378,451453,106656,398811,337675,829079,993017,287346,722209,7682,196227,260057,1039384,1038565,564383,126491,129239,106867,99718,68439,670883,648536,783853,889068,505943,58201,319151,937662,854509,687085,720266,541629,573167,169228,367740,934093,764234,439471,610821,856558,560934,392170,11504,34758,585229,957605,456310,825285,229988,194440,686506,862290,855288,282943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]