SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204513 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204513 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741566,38521,569164,1045469,677209,1000969,943028,841057,346396,517727,930771,464953,665346,360043,291247,772248,971983,427177,984435,1037716,764951,429659,71532,73608,534744,438236,804835,151475,415343,389324,733568,403521,390904,189423,993884,507760,139386,44712,577180,319538,886627,445684,352526,725091,1014238,731080,954920,149417,241933,1033478,202297,971882,89912,568994,837264,994682,406849,481326,879696,535070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]