SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504457 LIMIT 1 [ RunTime:0.001304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504457 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579808,921637,233924,328534,948125,726759,456436,873774,587046,2987,451864,240320,564729,74638,56583,341969,899251,280399,1000642,853581,978629,527330,210002,684363,226144,638925,963363,611802,206476,348058,728687,215368,982660,161452,986633,655421,204033,934219,325362,913201,236905,730061,416546,876516,638336,75523,193197,54878,158157,766258,286034,155150,548767,108944,340137,58576,658718,232641,70896,876615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000933s ]