SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247812 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247812 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993573,391899,985941,975651,701228,767954,918300,356417,193154,583677,321330,592122,1012243,342795,532484,918518,881358,898175,542432,430393,884599,360950,92538,663633,247114,979999,361691,742346,874961,989816,497482,92291,948338,922708,1007407,493251,285291,962875,440764,1008817,550708,803854,1031990,302032,912625,766037,629370,256391,263787,1028836,478559,642443,365702,522675,843575,572002,513634,431480,847513,2104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003851s ]