SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492091 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492091 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301310,633797,339261,127175,887066,124317,50643,288221,96305,731935,757952,500339,38308,44514,593615,102484,867111,225541,813188,838034,224938,96066,874080,285765,779867,247394,281003,70542,687557,845858,877565,265209,981111,888213,243479,134547,875923,639734,583267,877504,955677,947436,623125,412147,1043397,806894,929697,132174,764010,555386,1012310,57372,545663,860986,452728,161838,763841,597431,738983,827419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]