SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910703 LIMIT 1 [ RunTime:0.001899s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910703 [ RunTime:0.006455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601628,17763,696352,950309,471327,111144,923942,885770,467339,551024,913371,11956,660578,313843,207757,255982,984454,420469,376819,137255,175153,1023164,888220,209696,953188,669510,612250,90604,233525,426550,188125,147640,1041370,958047,319481,353947,460365,199787,506726,305678,754765,93651,943791,290960,685684,300047,353829,405537,297740,114696,873470,301973,823967,809722,92009,1038741,804624,41265,595735,99829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]