SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52904 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52904 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297253,958989,28311,730493,95617,896593,302271,389631,636490,570440,616229,1009057,51038,906518,607346,487414,447546,338488,64429,16027,530018,595038,326555,288892,506682,630114,834405,858943,830638,1029071,554852,1037122,121421,564498,933200,1021601,950928,497863,622820,734053,349148,762842,82526,11015,496277,576224,918202,650171,1027979,804956,820361,530682,555886,46951,270830,445719,453787,349897,945444,259876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]