SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68431 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68431 [ RunTime:0.003573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551281,750766,204074,328098,612571,972421,101859,933157,679554,572358,459059,100260,845052,453444,865556,585274,534047,430138,650519,233812,1015847,208014,865986,126638,552044,60717,858663,296411,971872,534093,355905,927415,48705,350306,184267,177882,272368,607855,563639,225864,335620,708447,1037997,663743,244869,608032,1007402,880120,950278,551542,584290,920579,256393,199444,883538,1042129,899887,695576,15618,616596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]