SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497980 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497980 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485035,345771,755907,720297,114796,327726,232524,607954,225987,584113,102823,852490,62435,593618,1034587,311105,4255,866946,168046,27135,601378,471707,792478,134032,634660,760066,913238,852110,1001580,205812,112630,362100,33650,717775,624313,593998,826997,930877,1002115,971096,246385,334918,362942,890951,1032953,707966,79618,441602,75807,1002208,260413,405550,754136,160673,451020,350953,844391,758285,897904,260999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000837s ]