SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42091 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42091 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328404,501650,21331,973377,632648,127029,165317,997287,260114,738616,458027,19655,942964,1027342,391405,562134,878074,568806,151051,890171,1014345,647441,608712,189843,587524,883939,193745,617715,421240,547373,785711,801655,29542,635005,750377,617442,600676,1021881,600626,214020,237138,15413,557887,943970,725855,17893,972456,706019,32896,643826,54780,757668,894964,858835,549691,48342,804126,918352,890183,1026879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]