SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467820 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467820 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588553,722164,944647,887686,334138,375075,115534,929141,964858,853074,351288,127170,870672,132538,63539,991005,766310,377480,218330,872318,808792,198031,951273,388376,957911,701467,433834,681871,23350,747630,222866,536464,21692,935435,912681,692015,501066,815139,187480,900330,873509,465652,38213,2659,761324,428706,135522,963228,989254,450492,791370,269879,912677,68654,320749,633941,117548,772039,901306,698772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]