SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578065 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578065 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861167,1033690,122016,105298,468014,956566,475580,511536,988249,83033,248381,406022,163122,569637,784941,729210,420162,512051,36307,179036,274716,226174,252901,697253,551334,906738,534593,584012,228508,973790,800002,646879,620130,838985,427723,380490,24799,44421,886707,899349,830630,49249,883575,926972,219941,615782,783881,1012014,520088,311120,496858,508812,360501,803528,843126,256641,960607,832650,496575,42735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]