SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 978660 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 978660 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022103,523468,174678,37389,560596,388706,278555,342970,300109,134812,878283,149235,202898,609558,451279,380320,1001842,608415,241475,127480,638777,848048,455682,449437,811679,815583,815894,360050,386072,502386,776074,1035774,47954,625127,1014115,397222,1008521,599860,671910,696526,902405,537234,395592,1011392,267172,412488,665753,1023056,128875,838085,924698,137946,152277,263454,865071,234975,449814,446051,503481,824317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001813s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 978660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 978660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002615s ]