SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400096 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400096 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939820,98244,356490,848316,587405,551655,536963,632151,595900,738233,496434,30610,583639,268948,558740,920033,123609,159412,796501,595863,1007887,547536,473704,962937,787456,149319,145777,225300,247963,403439,121522,983066,276631,404047,447096,247065,868889,665688,826820,713707,896312,536637,848407,883856,774916,542275,149998,118420,228531,494344,591589,274275,988110,817394,115444,285323,855777,294415,119271,353110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]