SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522613 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522613 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65924,109882,426747,264073,973999,363283,836822,686574,169616,575369,790429,36807,737763,390950,16120,152167,474137,890498,876148,313416,199235,240690,566499,822329,546185,451559,605834,65526,541218,259215,464365,1010166,348244,9616,96698,536163,438762,127340,581750,123224,875483,566998,188589,1015941,490292,40986,57967,783641,129240,364726,420398,618544,661707,12668,489967,629222,185850,928736,679235,354925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001607s ]