SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014193 LIMIT 1 [ RunTime:0.000763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014193 [ RunTime:0.005308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484529,91833,475719,465845,759782,410792,219032,127572,982100,565677,1041310,322055,739171,262477,832654,611641,912893,357791,652890,567149,755921,968027,742633,360413,79564,856585,554702,806192,537345,746132,647727,408975,740194,387980,697178,999343,1002979,713518,454171,720038,882576,217971,641904,125916,688733,937203,308734,748675,896690,976345,568484,222304,683303,548123,739325,808496,330297,257835,193773,670085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001632s ]