SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319396 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319396 [ RunTime:0.002673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183065,406418,66327,200594,135129,543712,1042305,169384,566456,75576,640147,765147,507185,871237,317328,837070,90801,160585,142952,267993,540623,470203,446182,575609,396768,462169,997888,509563,723757,706168,498571,1029166,708864,743343,774481,598057,957337,809478,85159,18498,527055,502622,12240,811777,680666,501160,198552,50710,264131,76871,686490,1037870,156043,500634,6866,560581,119339,503037,545708,886337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]