SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810771 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810771 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286774,85830,341122,945819,1039743,879970,754123,931894,828918,416954,689481,543344,645477,684378,710075,886081,320493,325615,771993,772203,964226,199593,1018081,146661,854391,297886,990845,279084,487339,864240,420517,702377,234998,1015559,228095,300668,120496,749835,933308,286294,240882,694189,695691,85577,768075,885940,997001,390683,211170,646591,902426,734596,867997,1030200,741767,813622,533804,918709,780555,890212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]