SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330400 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330400 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310716,562271,366877,440826,111342,714533,205764,453102,361895,835787,686075,10569,485186,172755,154502,960019,477932,792025,836849,923843,104233,445274,754136,300289,491657,50699,644530,393705,291972,3540,373612,305628,153872,723910,233143,60414,1048276,1029205,181160,270826,753259,656207,963005,676715,473184,432398,657949,1016149,664483,891451,745478,697036,452672,536866,163367,1001932,75415,352664,653809,1005967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]