SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459723 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459723 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27298,965581,569507,354718,856405,314272,895881,81726,47811,651829,25798,612058,902105,80158,7034,531540,537421,254058,680371,165406,845041,724899,733406,25285,881295,427358,366113,655,24674,324203,669875,390555,949140,148129,499862,371308,853344,869833,1022855,878404,483992,200379,758995,662093,980560,834145,94379,226775,824671,341213,501823,1021788,325025,201462,689233,9490,354417,1005907,536192,15269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]