SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42571 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42571 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007476,1000892,469670,328629,612272,708162,341796,799530,325561,389126,922296,177603,804453,708882,204457,164542,863159,72378,790803,239322,728221,878460,450292,119476,412619,209240,284056,731538,282434,392312,262151,5970,842302,189092,926878,916867,40914,157693,253103,114676,705905,712810,144801,55648,545011,1047850,431743,651470,927291,869257,355216,453673,639287,193584,318444,312631,711944,249122,163414,201510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]