SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672005 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672005 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77255,630599,378625,570117,889744,785782,469774,670345,910932,264663,265783,293376,440861,176823,257942,353312,915862,264284,769544,558668,614939,944162,876783,355543,197302,249797,849048,995695,115471,202059,14086,260879,1046127,163837,744626,461560,173513,510152,81183,240475,754807,944180,162861,561760,1016553,555842,373376,1035765,441693,59590,497262,1048671,606591,578608,795152,950255,137880,616782,802413,887298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]