SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002676s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034870 LIMIT 1 [ RunTime:0.003481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034870 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935657,38862,602801,938482,693842,963646,670819,720276,849870,491733,135687,710362,759653,315427,562914,73830,913439,1002884,180805,401108,37056,780289,315659,77194,56007,933422,423103,988422,597959,321644,672775,159231,782491,569815,80374,917423,892711,588454,580526,406003,1023402,601970,193464,251949,539787,70563,838672,598786,84727,476178,991745,322773,706814,477187,71550,850645,330931,521169,766715,8370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000362s ]