SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003681s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497611 LIMIT 1 [ RunTime:0.001702s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497611 [ RunTime:0.005321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45697,1030057,873159,216471,689751,721538,244022,625237,414333,226279,727933,940942,909237,32506,97139,949738,168394,319696,287875,808163,140403,529822,408207,647172,39003,310140,648565,335068,530571,962396,684676,296370,967511,689008,9631,502711,743022,923562,186745,252370,481770,850805,416444,725583,403935,67658,575963,491047,971135,895109,977991,306910,288747,847504,133674,37895,902710,520695,1036432,543045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001762s ]