SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002562s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455422 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455422 [ RunTime:0.002915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918855,120088,903324,700576,854285,205314,776507,1011176,591171,542752,619513,172717,396630,907124,603524,804830,352394,836444,969036,20920,795723,425758,388280,770147,271051,773993,534415,820677,266695,28164,31957,362996,892109,444000,832780,564292,622712,14991,261441,530891,342583,286006,934558,725772,297659,391920,62651,1036239,585026,351519,141563,549192,605593,128322,694216,797892,1002748,581799,134689,526402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]