SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684615 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684615 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414134,1039809,1042497,676058,103759,456076,440158,369937,947471,112928,209637,549743,743240,230375,808741,54322,272249,772246,148549,148367,665328,546121,162188,1017746,367586,375659,218889,658672,759635,589598,938071,808722,999093,77098,617356,140119,397744,311797,745289,86431,976304,318399,577967,1002010,200001,205380,582911,272084,125435,440059,979610,160640,536464,764337,384961,780533,520487,961870,302686,974176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001673s ]