SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33175 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33175 [ RunTime:0.003101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482823,144510,449575,426830,29302,772068,146463,153822,665748,320837,788189,1026348,890641,174173,636053,633861,820947,419404,1041664,252429,112272,480085,378625,466885,92889,1033489,692,852175,346817,286448,150204,969017,346159,568513,405209,779051,360338,177244,907217,537980,667825,210052,931625,229888,821764,608001,249811,512027,34032,750456,924809,699789,624347,923881,451884,559001,363807,917178,820073,367750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]