SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029698 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029698 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (361072,742035,366421,710648,328409,567142,196592,58028,551393,846958,294636,449207,578549,885498,533804,496456,406348,490531,267554,688635,804570,668753,684534,627852,234025,959628,817414,222226,853576,883935,663849,654315,452385,338080,869289,553254,895797,1021545,490173,302248,1012483,87782,1006068,533010,985644,754608,419202,215316,85457,301822,19625,807333,697397,523065,1001885,989818,761161,652426,134999,663302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]